Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
Can you help me to remove some rows in my load script with the following rule:
after different step i have a table like that:
I would like a script to remove the row
3rd row: Z 1 - AAA => because codntt = 1 exist with a codrisq other than Z
and
Z 4 - D => because codntt = 4 exist with a corisq other than Z
So at the end , i like to have a reduce table like that:
Notice:
As you can see , i keep Z 3 - CCC, because does not exist with another corisq other than Z
As you can see , Z 1 - AAA need to be remove, but the 2 rows with corisq = A and codntt = 1 should be kept.
thk you for your help.
Regards
I think you want a more general script.
Find attached !
View solution in original post
I believe this would help:
table:
LOAD Corisq,
cordntt,
nom,
nom2
Resident [source table]
Where Corisq<>'Z';
Concatenate(table)
Where Corisq='Z' AND not Exists(cordntt);
Hi zarmoton,
You can try the following code:
codntt,
FROM [Data.xlsx] (ooxml, embedded labels, table is Plan1)
Where not (codntt = 1 and Corisq = 'Z')
and not (codntt = 4 and Corisq = 'Z')
;
Hope this helps you.
excellent !
Thk you for your answer.
Very nice.
