• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using Connection Only Queries to another file

SMSSS

New Member
Hi,

Suppose I have 2 excel files "A" and "B". Assuming, file "A" has three connection only queries i.e A-COQ-01, A-COQ-02 and A-COQ-03. On the other hand, file "B" has just one query that is prepared as "Load to Table" its name is B-Query-01, but I want to merge connection only queries made in file "A" with query B-Query-01 that is made in file "B".

Thanks,
SM
 

Chihiro

Excel Ninja
As far as I'm aware, not possible. It may be possible using query on underlying xml and parsing query code, but I doubt it.

There isn't way for B file to parse M code in query.
 

vletm

Excel Ninja
SMSSS
You should reread Forum Rules
There are clear sentences about Cross-Posting, which You seems skipped.
Ps. Same kind of rules are everywhere and those are for You too.

SMSSS
Seems that You didn't reread those Forum Rules
neither #3 reply.
 
Last edited:

SMSSS

New Member
SMSSS
You should reread Forum Rules
There are clear sentences about Cross-Posting, which You seems skipped.
Ps. Same kind of rules are everywhere and those are for You too.

Hi, Vletm

Thanks for guidance, I'll post reference of my original post while doing cross posting. I thaought to get more experts through this forum so posted here too.
 
Top