Hello Everyone !
I have this table:
And i want create (in script editor) a table like this:
Remove the value in the third row of the field 2 !! Please Help me ! Thank you
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 -
Load * inline [
Field 1, Field 2
B, y ];
Load [Field 1],
If([Field 1]='A' and [Field 2]='y','',[Field 2]) as [Field 2]
Drop table T1;
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.
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 !!
Retrieving data ...