I have a table that I need to create subfields in to . all the fields are in Field propname , and the values associated to that field are in the propvalue field associated with the amsginfoexternalid for those fields, I did use Generic load, but I have some problems with transforming and the data was correct, however I had problems transforming the data after doing the generic load.. The fields I need created are [Customer Type] [Email Address] [Form Name Message] [Form Name] [Name On Form] [Operating Company] [Phone Number] [Question Type] [Request Type] [State] And [Submit Date] . also, out of curiousity , how would I implement incremental load using the QVC components script on this. ? Thank You in advance. I have attached the script and data
Solved! Go to Solution.
I am just wondering if this is even possible, instead of using a generic load, or if anything, a way to transform the generic load, such as if I wanted to create a master calendar from the submit date field, or to store it as a qvd? is that possible, or is it better to store the table as is as a qvd? and then do the generic load at the dashboard level
It looks like whatever you've done to create the "MsgInfoExternals.qvd.txt" was done in a crosstable when you actually want a straight table? Do you have the original data?
What I'm saying is that this qvd is a CrossTable BUT you want a straight table. Do you have the raw data? If so you can create a qvd in straight table format instead of cross table.
To be honest I'm wondering why you want to have a Straight Table instead of a Cross Table? What are you wanting to do that cannot be done using the data in this format?
All you need to do is use Set Analysis when creating tables / charts.
The fields I need created are [Customer Type] [Email Address] [Form Name Message] [Form Name] [Name On Form] [Operating Company] [Phone Number] [Question Type] [Request Type] [State] And [Submit Date which are values in this cross table, Then I would like to alter the data and even add a master calendar off of submit date.
What are you doing with the data though that requires those fields instead of a cross table? Look at the example attached. I've used Set Analysis within the QVW to create a chart / table that has Phone Number as a column. You can use the data in exactly the same way as a straight table.
You could create a Date field on the load using If statement. Then link to a master calendar
Thanks for the logic ,It Is just that I need those all as fields , you stated that I can use an if condtion, in script to create that as a field?