Skip to main content
Question

grouped excel values to SQL

  • June 25, 2015
  • 0 replies
  • 6 views
J
hello all,

 

 

i got an excel file with two columns, one with reference letter and one with a value,

 

i want to turn the values into headers within a SQL tables, each sql table being one reference number

 

what would be the best way going about it?

 

 

i have been messing around with listbuilder then expose the values which does give me one row per reference number, also each reference number has a different amount of values, so exposing them leaves a lot of missing values and i am still lost on how to turn them into header, maybe a custom transformer with a loop could help?

 

 

any help would be great, 

 

 
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.