Mdthbs

Is gzip atomic?

How do I prevent other wifi networks from showing up on my computer?

Can I get temporary health insurance while moving to the US?

Why do all fields in a QFT transform like *irreducible* representations of some group?

Add newline to prompt if it's too long

Asymmetric table

What are some interesting features that are common cross-linguistically but don't exist in English?

Does an atom recoil when photon radiate?

Where was Carl Sagan working on a plan to detonate a nuke on the Moon? Where was he applying when he leaked it?

How to respectfully refuse to assist co-workers with IT issues?

What is the best type of paint to paint a shipping container?

Duplicate instruments in unison in an orchestra

Transposing from C to Cm?

Non-visual Computers - thoughts?

Algorithms vs LP or MIP

What should come first—characters or plot?

Is there any way white can win?

Why 142857 is special??

"Sorry to bother you" in an email?

How to find out the average duration of the peer-review process for a given journal?

Prove your innocence

How do the Etherealness and Banishment spells interact?

Network helper class with retry logic on failure

Lost property on Portuguese trains

find the path of a data extension for a SQL Query

Retrive Data from Data ExtensionQuery a data extension in Marketing cloudSynchronized Data extensionhow to use query in marketing cloud that uses data extension for where clause?Load data from Synchronized Data source to Data ExtensionLoad Data from Synchronized data extension to data extensions by SQL QuerySQL Join Within Same Data Extension, SurveysSQL Query: Retrieve click data from journey

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

2

I need to find the path of a data extension that I use in a SQL Query.

I can find the name of it but because the data extension structure is very messy is hard to find it.

Is there a way in Salesforce Marketing Cloud to see that? Thanks!

marketing-cloud

share|improve this question

edited yesterday

Duicug

asked yesterday

DuicugDuicug

2855 bronze badges

add a comment | 

2

I need to find the path of a data extension that I use in a SQL Query.

I can find the name of it but because the data extension structure is very messy is hard to find it.

Is there a way in Salesforce Marketing Cloud to see that? Thanks!

marketing-cloud

share|improve this question

edited yesterday

Duicug

asked yesterday

DuicugDuicug

2855 bronze badges

add a comment | 

I need to find the path of a data extension that I use in a SQL Query.

I can find the name of it but because the data extension structure is very messy is hard to find it.

Is there a way in Salesforce Marketing Cloud to see that? Thanks!

marketing-cloud

share|improve this question

edited yesterday

Duicug

asked yesterday

DuicugDuicug

2855 bronze badges

share|improve this question

edited yesterday

Duicug

asked yesterday

DuicugDuicug

2855 bronze badges

share|improve this question

edited yesterday

Duicug

asked yesterday

DuicugDuicug

2855 bronze badges

asked yesterday

DuicugDuicug

2855 bronze badges

asked yesterday

DuicugDuicug

2855 bronze badges

2 Answers
2

active

oldest

votes

3

Yes, there's a script for that. Replace <DATA EXTENSION NAME> with the name of your DE.

<script runat=server>

Platform.Load("core","1.1.5");

var deName="<DATA EXTENSION NAME>";

var FolderScript= DataExtension.Retrieve({Property:"Name",SimpleOperator:"equals",Value:deName});

({Property:"CustomerKey",SimpleOperator:"equals",Value:key}); 

var FolderID = FolderScript[0].CategoryID;

var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:FolderID});



var folderName = results [0].Name;

var parentFolder=results [0].ParentFolder.Name;

var countdown = function(id) {

    if (id> 0) {

        var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:id});

    Write(results [0].Name+">");

        return countdown(results[0].ParentFolder.ID);

    } else {

        return id;

    }

};

countdown(FolderID);

</script>

Mind that the path you get will be the other way around, right to left.

share|improve this answer

edited yesterday

answered yesterday

CodeRageCodeRage

1,02822 silver badges1818 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, I'm new to marketing cloud. Not sure where do I run the script, can you give me a hint please
  
  – Duicug
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  WebStudio>CloudPages. Create a new collection, inside the collection create a new landing page. Add a plain HTML content block and paste it there. Hit publish, and the path will be displayed on-screen. No need to actually publish it.
  
  – CodeRage
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  CodeRage, I have updated my question with a screenshot. It doesn't seem to work. I have changed the data extension name with different data extension names but it doesn't show anything
  
  – Duicug
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Click on Publish in top right corner and take out the <> around DE name
  
  – CodeRage
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  sorry, the problem was the brackets. Thanks a lot
  
  – Duicug
  yesterday
  

  
  
  
  

 | 
show 3 more comments

1

I would also suggest this chrome extension 'SFMC OBJECT FINDER'

Users find difficult to track down a Object location from the Salesforce Marketing Cloud platform.

This extension would help users to search for a Object from the platform and display the exact location.

share|improve this answer

answered yesterday

EazyEEazyE

2,54111 silver badge1616 bronze badges

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "459"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f274705%2ffind-the-path-of-a-data-extension-for-a-sql-query%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

3

Yes, there's a script for that. Replace <DATA EXTENSION NAME> with the name of your DE.

<script runat=server>

Platform.Load("core","1.1.5");

var deName="<DATA EXTENSION NAME>";

var FolderScript= DataExtension.Retrieve({Property:"Name",SimpleOperator:"equals",Value:deName});

({Property:"CustomerKey",SimpleOperator:"equals",Value:key}); 

var FolderID = FolderScript[0].CategoryID;

var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:FolderID});



var folderName = results [0].Name;

var parentFolder=results [0].ParentFolder.Name;

var countdown = function(id) {

    if (id> 0) {

        var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:id});

    Write(results [0].Name+">");

        return countdown(results[0].ParentFolder.ID);

    } else {

        return id;

    }

};

countdown(FolderID);

</script>

Mind that the path you get will be the other way around, right to left.

share|improve this answer

edited yesterday

answered yesterday

CodeRageCodeRage

1,02822 silver badges1818 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, I'm new to marketing cloud. Not sure where do I run the script, can you give me a hint please
  
  – Duicug
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  WebStudio>CloudPages. Create a new collection, inside the collection create a new landing page. Add a plain HTML content block and paste it there. Hit publish, and the path will be displayed on-screen. No need to actually publish it.
  
  – CodeRage
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  CodeRage, I have updated my question with a screenshot. It doesn't seem to work. I have changed the data extension name with different data extension names but it doesn't show anything
  
  – Duicug
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Click on Publish in top right corner and take out the <> around DE name
  
  – CodeRage
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  sorry, the problem was the brackets. Thanks a lot
  
  – Duicug
  yesterday
  

  
  
  
  

 | 
show 3 more comments

3

Yes, there's a script for that. Replace <DATA EXTENSION NAME> with the name of your DE.

<script runat=server>

Platform.Load("core","1.1.5");

var deName="<DATA EXTENSION NAME>";

var FolderScript= DataExtension.Retrieve({Property:"Name",SimpleOperator:"equals",Value:deName});

({Property:"CustomerKey",SimpleOperator:"equals",Value:key}); 

var FolderID = FolderScript[0].CategoryID;

var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:FolderID});



var folderName = results [0].Name;

var parentFolder=results [0].ParentFolder.Name;

var countdown = function(id) {

    if (id> 0) {

        var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:id});

    Write(results [0].Name+">");

        return countdown(results[0].ParentFolder.ID);

    } else {

        return id;

    }

};

countdown(FolderID);

</script>

Mind that the path you get will be the other way around, right to left.

share|improve this answer

edited yesterday

answered yesterday

CodeRageCodeRage

1,02822 silver badges1818 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, I'm new to marketing cloud. Not sure where do I run the script, can you give me a hint please
  
  – Duicug
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  WebStudio>CloudPages. Create a new collection, inside the collection create a new landing page. Add a plain HTML content block and paste it there. Hit publish, and the path will be displayed on-screen. No need to actually publish it.
  
  – CodeRage
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  CodeRage, I have updated my question with a screenshot. It doesn't seem to work. I have changed the data extension name with different data extension names but it doesn't show anything
  
  – Duicug
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Click on Publish in top right corner and take out the <> around DE name
  
  – CodeRage
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  sorry, the problem was the brackets. Thanks a lot
  
  – Duicug
  yesterday
  

  
  
  
  

 | 
show 3 more comments

Yes, there's a script for that. Replace <DATA EXTENSION NAME> with the name of your DE.

<script runat=server>

Platform.Load("core","1.1.5");

var deName="<DATA EXTENSION NAME>";

var FolderScript= DataExtension.Retrieve({Property:"Name",SimpleOperator:"equals",Value:deName});

({Property:"CustomerKey",SimpleOperator:"equals",Value:key}); 

var FolderID = FolderScript[0].CategoryID;

var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:FolderID});



var folderName = results [0].Name;

var parentFolder=results [0].ParentFolder.Name;

var countdown = function(id) {

    if (id> 0) {

        var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:id});

    Write(results [0].Name+">");

        return countdown(results[0].ParentFolder.ID);

    } else {

        return id;

    }

};

countdown(FolderID);

</script>

Mind that the path you get will be the other way around, right to left.

share|improve this answer

edited yesterday

answered yesterday

CodeRageCodeRage

1,02822 silver badges1818 bronze badges

<script runat=server>

Platform.Load("core","1.1.5");

var deName="<DATA EXTENSION NAME>";

var FolderScript= DataExtension.Retrieve({Property:"Name",SimpleOperator:"equals",Value:deName});

({Property:"CustomerKey",SimpleOperator:"equals",Value:key}); 

var FolderID = FolderScript[0].CategoryID;

var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:FolderID});



var folderName = results [0].Name;

var parentFolder=results [0].ParentFolder.Name;

var countdown = function(id) {

    if (id> 0) {

        var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:id});

    Write(results [0].Name+">");

        return countdown(results[0].ParentFolder.ID);

    } else {

        return id;

    }

};

countdown(FolderID);

</script>

share|improve this answer

edited yesterday

answered yesterday

CodeRageCodeRage

1,02822 silver badges1818 bronze badges

answered yesterday

CodeRageCodeRage

1,02822 silver badges1818 bronze badges

answered yesterday

CodeRageCodeRage

1,02822 silver badges1818 bronze badges

1

I would also suggest this chrome extension 'SFMC OBJECT FINDER'

Users find difficult to track down a Object location from the Salesforce Marketing Cloud platform.

This extension would help users to search for a Object from the platform and display the exact location.

share|improve this answer

answered yesterday

EazyEEazyE

2,54111 silver badge1616 bronze badges

add a comment | 

1

I would also suggest this chrome extension 'SFMC OBJECT FINDER'

Users find difficult to track down a Object location from the Salesforce Marketing Cloud platform.

This extension would help users to search for a Object from the platform and display the exact location.

share|improve this answer

answered yesterday

EazyEEazyE

2,54111 silver badge1616 bronze badges

add a comment | 

I would also suggest this chrome extension 'SFMC OBJECT FINDER'

Users find difficult to track down a Object location from the Salesforce Marketing Cloud platform.

This extension would help users to search for a Object from the platform and display the exact location.

share|improve this answer

answered yesterday

EazyEEazyE

2,54111 silver badge1616 bronze badges

share|improve this answer

answered yesterday

EazyEEazyE

2,54111 silver badge1616 bronze badges

answered yesterday

EazyEEazyE

2,54111 silver badge1616 bronze badges

answered yesterday

EazyEEazyE

2,54111 silver badge1616 bronze badges