where is File Wizard : Transform?

[#1]

HI,

Can anyone let me know where I can see File Wizard: Transform

Thanks.

[sunny_talwar]

Step 1 and 2

Step 3

[tresesco]

Script editor->Table Files, select a file (may be an excel) ->OK->Next... it's there

[#4]

Thanks. got it. that is for any excel file. if I want to transpose any straight or pivot table rows to columns or columns to rows how do I need to do that?

please suggest me

[sunny_talwar]

For pivot table to a regular table conversion I would use CrossTable which you can get to by clicking next on this screen. and for transposing stuff you need to click on 'Enable Transformation Step' and then it you will see 5-6 options up top. One of them would be rotate you can use that to transpose or left or right lanes. Play around with it to see what it is doing.

[#6]

Thanks. so, do I need to first right click on straight or pivot table to get b this screen? sorry I am not sure

[sunny_talwar]

Are you trying to visualize QlikView's object in a different orientation?

Try this for straight table:

For pivot table you can drag the dimensions to pivot stuff.

What I mentioned earlier was for loading the data. That cannot be used for QlikView's front end objects.

[#8]

perfect Thanks. is there any way that I can put one column as horizontal and another one to vertical

I need 8 columns to horizontal and 1 column to display vertical

would it be possible?

[sunny_talwar]

‌That requirement sounds more like a Pivot table kind of table

[#10]

yes with pivot table I can able to get 8 columns ok. but the 9 and 10th columns are not showing what my user want.

actually I need like below. I can not able to get constantvaliue and Difference columns

Difference column values are Total - constantvalue

data	19/02/2016	22/02/2016	23/02/2016	24/02/2016	25/02/2016	Total	constant value	Difference
we	4	3.00	5	3	1	16	32	-16
er	1	4	3	2	0	10	32	-22
tr	1	4	2	2	0	9	32	-23
%	100%	100%	67%	100%		90%	32
erq	3	8	3	0	8	22	32	-10
sdf	4	8	6	2	11	31	32	-1
adc	2	10	0	11	5	28	32	-4
cds	7	9	13	8	9	46	32	14

can you help me how to add constantvaliue and Difference columns