Forum Discussion
Web.Content Custom Connector Folding
Thanks lbendlin for your feedback
Just to clearify what you say...
lets takes this structure for an example:
for the first page I have table with ID, Column1, Column2
but when I pulled page #2 I got table with ID, Column2, Column3
is this is something that Incremental Refresh will "know" how to handle - by append Column2 data, Add new Column3 and append thits data, and not remove Column1?
and what about if on page #3 I got table with ID, Column4, Column35
will it Add Column4 and Column35 to existing table?
the question is: what is the logic behined Incremental Refresh?
Is it: "when get next table - find if there is already Column with same name - if so - then append accordingly, and if it's not exist, Add new Column. And never remove Columns"?
Another question:
Is the first row for each page - must be filled with data under all table columns?
so if I have page #2 (on same example) that contains: ID, Column2, Column3 but on first row Column2 is empty
it will lead to faliure?
so I need to make sure the first row of any page - start with data for all Columns on that page
or should it be enough that I got page with columns: ID, Column5, Column6, Column7
and the rows will be like that:
row #1 - has data on Column5 (no data on others)
row #2 - has data on Column6 (no data on others)
row #3 - has data on Column7 (no data on others)
what will be the result then? will it lead to error?
Thanks very much for your help,
I'm tryig to be clear with specific examples so I will understand the answer and know what should I do to avoid such errors
- lbendlin2 years agoSuper User
Unpivot your data into key/value columns.
- LiranRom2 years agoHelper I
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
- lbendlin2 years agoSuper User
where is the DateTime column that you are planning to use for the partition boundaries?