9 Replies Latest reply: Sep 10, 2018 8:12 AM by David Štorek RSS

    changing time format every day

    James Hunt

      Hello Everyone,


      in this question/discussion I was given a solution to my time format problem (https://community.qlik.com/thread/309548)


      "Time(Time#(TPTIPP, If(Len(Trim(TPTIPP)) = 5, 'hmmss', 'hhmmss'))) AS [Time-scan-to-bin-location-return]"


      Now I have the issue, that I need to upload data every day and have to manually paste the solution into the script.


      Is it possible to create a new section which will regonize that the field names (2 or more per section) in 2 different sections are the same and automatically create a synch key or something like it?


      Really appreciate  your help