Forum Discussion
Web.Content Custom Connector Folding
Unpivot your data into key/value columns.
the Pivot is the way I use for Expand the list of objects, into flatten columns in the source table.
UnPivot - is not the answer for my issue.
I do need to Expand the list - into flatten columns.
and the question what is the Inremental Refresh limit that prevent me to do that
where is the DateTime column that you are planning to use for the partition boundaries?
one of the table columns is a DateTime column (meaning: in any row there is ID, datetime, and more columns..)
therefore the partition and Incremental Refresh works great when the columns are the same for all rows.
the problem start only when I started to Expand the list key,value column into dynamic columns ..Add a fake row to each table that has all the columns you will ever see in the individual sources.
Or, do the right thing and unpivot your data.