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