topic Combine two field values in straight table in QlikView

Combine two field values in straight table

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

Combine two field values and create expression in a straight table, as per below screenshot

Re: Combine two field values in straight table

johnca — Tue, 25 Feb 2020 15:06:56 GMT

Karan, have you tried something like this?

KeepChar(New,'.0123456789') - KeepChar(Old,'.0123456789')

HTH,

John

Re: Combine two field values in straight table

martinpohl — Tue, 25 Feb 2020 15:07:37 GMT

see attached

Regards

Re: Combine two field values in straight table

rajaxavier — Sun, 26 Apr 2020 13:15:12 GMT

Tab:
LOAD * INLINE [
ID,OLD,NEW
1,03-BAC,02-ZAC
2,02-BAC,02-BAC
3,04-TAC,04-TAC
4,01-CAC,02-ZAC
5,01-CAC,04-TAC
6,01.5-CAC,02-ZAC
7,01-CAC,04-TAC
8,02-ZAC,03-BAC
9,01-CAC,03-BAC
10,02-ZAC,02-ZAC
];

TAB1:
LOAD * ,
SubField(NEW,'-',1) - SubField(OLD,'-',1) AS OUTPUT
Resident Tab;

Drop Table Tab;