compare two fields

[#1]

Hi

Can you help me?

I compare two fields in script.

property 'Yes' - works correctly,

but property 'No' - incorrectly.

T

Tanks you

[PradeepReddy]

can you explain your requirement in detail?

[Chanty4u]

i thnk for   "no" there is data not available

[Chanty4u]

or can u share the script which u hve used to create property?

[sunny_talwar]

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;

[PradeepReddy]

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;

[Gysbert_Wassenaar]

'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.

[#8]

I want to get a list of 2

[#9]

I want to get a list of 2

[PradeepReddy]

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..