Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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];
Does Closed Square bracket needed in your statement? remove that and it works
Hi Suresh,
Try Below one:
Load....
...
If(Len(Trim(Status))>0,Status,[C_Status]) as Sale
From.....
Thanks,
Arvind Patil
What is your actual requirement ????
If(Len(trim(Status))=0,[C_Status],Status) As Sale;
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;
From ?
Status is from Temp2 Table
C_Stautus is from Temp 1 and Temp 3 Table.
how should i write the From.......
columns are coming from different tables ?? then you need to map them to one table ..share the complete script will check and suggest
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.
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;