Discussion board where members can get started with Qlik Sense.
let's assume we have two tables and we want to join them via one key field (field1).
But, the value format of the key field in both tables is different:
How can i change the value format of e.g. fieldA (0000000000) of table1
into the value format of field1 (00-000-0000/0) of table2 (master)?
May be like this:
Left(fieldA, 2) & '-'&Mid(fieldA, 3, 3)& '-' & Mid(fieldA, 6, 4) & '/' & Right(fieldA, 1)
View solution in original post
Autonumber(keepchar(field1,'00' ) ) as FieldA
Autonumber(FieldA) as FieldA
As always Sunny, works perfectly fine.
Thanks a lot