4 Replies Latest reply: Jan 17, 2011 1:43 PM by Onur Civelek RSS

    How to put Dummy row in a loaded table

       

      Hi,

      how can i add only one dummy row to a loaded csv.Table within the script ?

       

      Here are my construct:

      HEL_DATA:
      LOAD

      [Kunden ID] AS [HEL_DATA_Kunden ID],
      [Werbetreibenden ID] AS [HEL_DATA_Werbetreibenden ID],
      [Seiten ID] AS [HEL_DATA_Seiten ID]

      FROM H:\Qlikview Workspace\APILoader\reports\28783*.csv (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

       

      I tried with this supplement. But when i run the script, i get syntetic keys !

      HEL_DATA:
      ADD LOAD * INLINE [
      HEL_DATA_Kunden ID, HEL_DATA_Werbetreibenden ID, HEL_DATA_Seiten ID
      jonny, 9001, 200
      ];

       

      Thank you for your help.

      Best regards