Discussion board where members can learn more about Qlik Sense App Development and Usage.
In my column (Unique identifier) I have data in this format 111122223333. I want to have data as 1111_2222_3333 format. This column has more that 150k records. How can i replace data from this format 111122223333 to 1111_2222_3333.
Can I do this in my load script when i load the unique identifier column? Thank you in advance!
Solved! Go to Solution.
then why don't you replace the '_' with '' in the key of your other tables? that is relatively simpler!
so all your keys are in 111122223333 format without the '_'
Thanks for the suggestion. Can you give me an example. I can change the format of either of the table. Can you give me an example for it ?
I would be careful about removing the '_' as it is a character delimiter that can make all the difference as a unique identifier. If your field is always formatted the same way, Eg 12 characters long, then removing the '_' can work. However if the format is not structured, then removing the '_' may also remove the uniqueness. For example 1_23 and 12_3 would both be represented as 123 if you removed the '_', and therefore you can no longer use that field to distinguish between 1_23 and 12_3.