Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Problem loading data from Microsoft DWH


I have a problem during the extraction from dwh.

I noticed that if I load data and store them in local, in the qvd file some code, like 175, 0175 and 00175, are stored all like '175'.

Cause I have write an automatic script for having a staging area 1:1 with DWH, there is a way for doing it without auto-traslation of data-type?


2 Replies

Re: Problem loading data from Microsoft DWH

Maybe using

Text(field) as field

in the load?



Not applicable

Re: Problem loading data from Microsoft DWH

Thanks Marco for your reply.

Maybe you could  have  reason but...it's not so now, sorry.

You are not thinking in the automatic script.

I need to staging 138 tables...do you think really the right way is writing 138 load instructions checking for each table what is the field I have to translate and what no?

Well now seriously, the ONLY  working way is a preceding load on an extraction from DWH.

I am writing a script with variables for checking from a list the fields I have to translate.  So the script check if the field is in the table or not, modifying loading script according to the situation.

Someone have a better idea for this case,  please?

Thanks to all

Community Browser