topic Re: Problem loading data from Microsoft DWH in QlikView

Problem loading data from Microsoft DWH

Thu, 01 Sep 2016 13:57:56 GMT

Hi,

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?

Thanks

Re: Problem loading data from Microsoft DWH

MarcoWedel — Thu, 01 Sep 2016 21:33:32 GMT

Maybe using

Text(field) as field

in the load?

regards

Marco

Re: Problem loading data from Microsoft DWH

Thu, 01 Sep 2016 23:01:06 GMT

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