4 Replies Latest reply: Apr 10, 2016 8:03 AM by Stefan Wühl RSS

    Populate empty field with random ID?

    Roberto guerra

      Hi! I'm gathering different Excel Sheets from a third party which have no Unique field except for the title and i'm fearing that these might repeat themselves eventually. Is there any way that Qlikview can autocomplete blank fields with unique ID's every time it loads?

       

      I plan to include new excel spreadsheets every week, so I won't have time to do this myself. Any clues? I was thinking something like...

      "If Title already exists, Add random character from A-Z at the end and use it as ID".

       

      Or maybe it's even simpler... and I can just auto complete a blank column with random values for each load.

       

      Thank you very much !!