Load the Condition Table

[Anonymous]

Hello Team,

I have few other tables in script, i need to add the below condition , Please help

If(Len(Status)=0,[C_Status],Status) As Sale];

[Anil_Babu_Samineni]

Does Closed Square bracket needed in your statement? remove that and it works

[arvind_patil]

Hi Suresh,

Try Below one:

Load....

...

If(Len(Trim(Status))>0,Status,[C_Status]) as Sale

From.....

Thanks,

Arvind Patil

[avinashelite]

What is your actual requirement ????

If(Len(trim(Status))=0,[C_Status],Status) As Sale;

[its_anandrjs]

You wrongly put the bracket ( ']' ) remove this from script or check your sale field

Try this

Load

If( Len(Status) = 0, [C_Status], Status ) As Sale;

From Source;

[Anonymous]

From ?

Status is from Temp2 Table

C_Stautus is from Temp 1 and Temp 3 Table.

how should i write the From.......

[avinashelite]

columns are coming from different tables ?? then you need to map them to one table ..share the complete script will check and suggest

[its_anandrjs]

On calculated Dimension you can try this or share the sample

If( Len(Status) = 0, [C_Status], Status)

Note:- And values suppress null should be selected.

[Anil_Babu_Samineni]

Try this? Or post sample application in inline to check

Main:

Load Status From T2;

Join

Load C_Status from T1;

Concatenate

Load C_STatus from T3;

Final:

Load *, If(Len(Status)=0,C_Status,Status) As Sale Resident Main

Drop Table Main;

OR

Main:

Load Status From T2;

Load C_Status from T1;

Inner Join (T1)

Load C_STatus from T3;