Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Check field equal and dont show result in other field

Hello Everyone !

I have this table:

Field 1Field 2
Ax
Ax
Ay
By
By

And i want create (in script editor) a table like this:

Field 1Field 2
Ax
Ax
A
By
By

Remove the value in the third row of the field 2 !! Please Help me ! Thank you

1 Solution

Accepted Solutions
Digvijay_Singh

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;

View solution in original post

6 Replies
jonas_rezende
Specialist
Specialist

Hi, Joao Ribeiro.

What is the rule to keep and remove?

Hope this helps!

Digvijay_Singh

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;

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

Thank you All !!

Not applicable
Author

Thank you! it work's with numbers, but not work with dates...

do you know why ?!

Digvijay_Singh

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.