Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone !
I have this table:
Field 1 | Field 2 |
---|---|
A | x |
A | x |
A | y |
B | y |
B | y |
And i want create (in script editor) a table like this:
Field 1 | Field 2 |
---|---|
A | x |
A | x |
A | |
B | y |
B | y |
Remove the value in the third row of the field 2 !! Please Help me ! Thank you
Not sure why are you doing it, if you just want to remove value, you can do as -
T1:
Load * inline [
Field 1, Field 2
A, x
A, x
A, y
B, y
B, y ];
NoConcatenate
Final:
Load [Field 1],
If([Field 1]='A' and [Field 2]='y','',[Field 2]) as [Field 2]
Resident T1;
Drop table T1;
Hi, Joao Ribeiro.
What is the rule to keep and remove?
Hope this helps!
Not sure why are you doing it, if you just want to remove value, you can do as -
T1:
Load * inline [
Field 1, Field 2
A, x
A, x
A, y
B, y
B, y ];
NoConcatenate
Final:
Load [Field 1],
If([Field 1]='A' and [Field 2]='y','',[Field 2]) as [Field 2]
Resident T1;
Drop table T1;
Do you mean, You want to keep as Repeated rows also or what. this seems not a make sense to do. Can you describe more
Thank you All !!
Thank you! it work's with numbers, but not work with dates...
do you know why ?!
May be some formatting issue while matching, as dates are stored as nos as well as text, can u share small sample data, I will make it work probably.