Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Creating Ad-hoc tables

Avatar

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
jael91407431
Level 3

13-12-2017

Hi,

I'd like to throw this out the community to see the best response:

I wish to create an ad-hoc table in our AC instance for the purpose of querying.

From what I understand, I can either create a list or another table.

A list is a temporary if a convenient way to query that contains data or entities (like indexing) but on a temporary basis. But a list's data can only contain data that's already contained in our database, is this correct?

Secondly, ad-hoc tables (a table developed for certain workflows for example, which we can discard later) is no different than creating any other table, is this correct?

In other words, I wish to create a data table that houses temporary data, to be discarded, if necessary if the data is not longer useful.

What is the best approach to creating ad-hoc, temporary tables?

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
RamaRajesh
Employee

14-12-2017

Hi,

A table can be created out of an existing table (schema) of the data model or a new one (new schema). Once the table is created, we can upload the data by querying the existing table or using a flat file.

A list can be created out of an existing table by querying (select all recipients from recipient schema where country= USA) it. Or, by creating a list and updating the list with flat file data.

So, a list can be created out of the adhoc data which is not present in the data model, already.

For your case, a temp table or a list should work whichever is the easy way for you.

Thanks,

Rajesh

Answers (0)