topic Re: QV Expressor Data Fetch in QlikView

QV Expressor Data Fetch

senpradip007 — Fri, 03 Jan 2014 09:28:04 GMT

Hi Members,

I am new in QlikView Expressor and I want to fetch data from QlikView (.QVX) file. But I'm getting an error.

Thanx in advance.

Fri, 03 Jan 2014 14:32:05 GMT

Hello,

You are getting error because you have just selected Read operator.

The correct steps will be as follows

1 Go to create tab and create delimeted schema from the QVX file you have at file path connection.

2 Take necessary transform operators and do the transformation

3 Take write operator.

4 Go to create tab and create delimited schema from upstream output

5 Give output file name and table name.

Hope this answer will be helpful for you.

Regards,

Prakash

senpradip007 — Mon, 06 Jan 2014 05:53:20 GMT

Thanks Prakash.

It's really helpful to me.

Now I want to implement "INCREMENTAL LOAD" in Expressor.

From a source file I have loaded the initial data. Now with this same file but different sheet I want to load the new data.

For example,

In Sheet1

ID, Name

1, AA

2, BB

In Sheet2

ID, Name

1, AA

2, BB

3, CC

4, DD

I want to load the ID 3 and 4.

Please help me how to crack it.