Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can you help me?
I compare two fields in script.
property 'Yes' - works correctly,
but property 'No' - incorrectly.
T
Tanks you
can you explain your requirement in detail?
i thnk for "no" there is data not available
or can u share the script which u hve used to create property?
Document is repeating multiple times leading to Cartesian Product. Try this:
1:
LOAD RowNo() as UI,
If(document = 'document2', branch) as branch1,
document
FROM
[test (1).xlsx]
(ooxml, embedded labels, table is Лист1);
left Join(1)
LOAD RowNo() as UI,
branch,
document
FROM
[test (1).xlsx]
(ooxml, embedded labels, table is Лист1);
2:
LOAD *,
If([branch] = [branch1], 'Yes', 'No') as property
Resident 1;
DROP Table 1;
As of my understanding, you are trying to achieve
If document= 'Document2' then Property='Yes' else No.. If this is the scenario try bellow script..
Load *,
if(document= 'Document2','Yes','No') as property
from Source;
'No' works properly too. All branches are possible if you select No. Check your data. Maybe you want to use INNER JOIN instead of LEFT JOIN.
I want to get a list of 2
I want to get a list of 2
as per the data provided, you will get the all branches for Priority='No'.
Provide what you are trying to get achieve from the data and logic to achieve the same..