Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Qlik desktop and doing some testing. I have a number of items in a table. What I want to do is create a new (True/False) table. If the filed in a table has "V" at the end of a field I want the corresponding field to put in "FALSE"
Example
Table 1 | New Col (True/False) |
---|---|
12345V | FALSE |
abcdeV | FALSE |
1qaz2wsx | |
1234qwer | |
7652ygV | FALSE |
How does one do that in qlikview desktop?
TIA
May be this
If(Right([Table 1], 1) = 'V', 'False', 'True') as [New Col]
I tried something like that then yours. I get back "unrecognized symbol: =" each time
Seems to work
Table:
LOAD *,
If(Right([Table 1], 1) = 'V', 'False', 'True') as [New Col];
LOAD * INLINE [
Table 1
12345V
abcdeV
1qaz2wsx
1234qwer
7652ygV
];