locked
My date range changes every day and I get an error in the dates that are no longer in the new data set RRS feed

  • Question

  • Hi

    I really just unpivot a data set after some transformations. But the query shows an error as some of the dates are not in the <g class="gr_ gr_206 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="206" id="206">new</g> imported table.  What do I have to do to just make the query run with dropping <g class="gr_ gr_379 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id="379" id="379">and</g> old date and adding a new?

    Sorry if this is not clear

    Cheers

    Andrew

    Thursday, December 13, 2018 10:01 PM

Answers

  • Excel 365 Pro Plus with PowerPivot and Power Query (aka Get & Transform)
    No OP file so far.
    Here is a rather artificial example that possibly matches his error.
    I often see this error when duplicating queries.
    The old data is retained and not overwritten by the new source.
    Query Table13 shows this error.
    Query Table14 corrects this with an added step (ColNa).
    Q14 is also now neater.
    http://www.mediafire.com/file/8sllolbuio11e2w/12_15_18.xlsx/file

    Sunday, December 16, 2018 4:12 PM

All replies

  • Hi

    Sorry if this is not clear

    Not unclear but without a view on your code + a subset of the actual data it's virtually impossible to help...

    Thursday, December 13, 2018 11:09 PM
  • Excel 365 Pro Plus with PowerPivot and Power Query (aka Get & Transform)
    No OP file so far.
    Here is a rather artificial example that possibly matches his error.
    I often see this error when duplicating queries.
    The old data is retained and not overwritten by the new source.
    Query Table13 shows this error.
    Query Table14 corrects this with an added step (ColNa).
    Q14 is also now neater.
    http://www.mediafire.com/file/8sllolbuio11e2w/12_15_18.xlsx/file

    Sunday, December 16, 2018 4:12 PM