3 Replies Latest reply: Feb 10, 2016 10:48 AM by Puttemans Johan RSS

    Qlikview to read different .csv files at the same time

    Kevin Bouwer

      Hi

       

      I am using QV for sports analysis reports

       

      Currently, I get data from 2 separate sources which export the data as .csv files

      For csv file 1, I use the following to import the csv

       

      FROM

      [$(vPATH)\*.csv]

      (txt, unicode, embedded labels, delimiter is '\t', msq);

       

      This does not pick up csv file 2

      For csv 2 I have to use the following to import the csv (When using this path, QV does not pick up csv file 1

       

      FROM

      [$(vPATH)\*.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

       

      Is there a way for QV to pick up both types of CSV files I Have attached samples of both csv files