topic Re: Save specific fields from table-box as different fields to QVD using macro? in QlikView

Save specific fields from table-box as different fields to QVD using macro?

Mon, 29 Dec 2014 08:27:53 GMT

Hi,

I have two requirements:

1. To save specific fields and not all the fields from a Table-Box into QVD.

2. The resultant QVD should have that many different fields as are saved in the step above (and not one field).

For example, my table-box may contain 5 Fields. F1, F2, F3, F4 and F5.

I need to write macro to pick only F4 and F5 from table-box and save it as two different fields (and 'not' concatenated as one field) in a QVD.

From community I came to know about the following piece: But, It saves the whole Table-Box and all fields are concatenated as a single field in the QVD

set obj = ActiveDocument.GetSheetObject("TB01")
obj.Export "D:\Developer\Cash\Sett.qvd", 4

Re: Save specific fields from table-box as different fields to QVD using macro?

Gysbert_Wassenaar — Mon, 29 Dec 2014 10:41:55 GMT

Create another table box with only the fields you need and export that table box with your macro. You can hide the table box so the users won't see it.

Re: Save specific fields from table-box as different fields to QVD using macro?

Mon, 29 Dec 2014 10:57:41 GMT

Thanks for your reply.

Approach you suggested helps me except a condition. My table-box actually contains a column as INPUTFIELD (takes user input). And I have another column that contains the RowNo. So, I want to store these two columns only, from TableBox, once the user finishes all the inputs. Therefore the value of a column in not known during reload and that stops me to create a sperate hidden table.

Re: Save specific fields from table-box as different fields to QVD using macro?

Gysbert_Wassenaar — Mon, 29 Dec 2014 11:07:54 GMT

I don't understand why the inputfield would stop you from creating two table boxes and hiding one of them. Can you explain that?

Re: Save specific fields from table-box as different fields to QVD using macro?

Tue, 30 Dec 2014 08:52:22 GMT

Hi Gysbert.

I am not sure if I explained my problem in right direction. But, if InputField is one among many fields inside a table box, how then we can select this particular InputField and save it in a seperate table-box. I want to achieve this at the button click event (external-macro). Please let me know if I need to produce an example to understand this in a better way.

Re: Save specific fields from table-box as different fields to QVD using macro?

Tue, 30 Dec 2014 09:36:23 GMT

Hi - The situation is simlar to the Table-box show below:

ID	TicketNo	Currency	Paid	Rcvd	Balance	Relevant_TXN_ID
1	US320	USD	200			3
2	US324	USD		-110		3
3	TXN401				90	3
4	UK119	EUR	176			7
5	UK121	EUR		-76		7
6	UK128	EUR		-100		7
7	TXN431				0	7

Here "Relevant_TXN_ID" is in InputField. I need to save two columns "ID" and "Relevant_TXN_ID" in a QVD as two different columns, at the Button-Click event.

Re: Save specific fields from table-box as different fields to QVD using macro?

Mon, 05 Jan 2015 06:40:12 GMT

Can anyone please help me with this issue?