Stack Overflow
Stack Overflow

Questions tagged [foundry-contour]

Questions related to development using Palantir Foundry's Contour application are appropriate to use here.

Contour is the point-and-click data analysis tool that allows you to quickly access datasets, conduct common analytical and logical operations in sequence to explore your data, debug data quality, cleanse and transform your data, and create reports to share your findings with others.

31 questions
1
vote
1 answer

How can I embed clickable URL hyperlinks in data columns in Contour?

I have a Foundry table that has a column full of URLs, represented as a String type. I want to make the elements of this column into clickable hyperlinks so that a user using Contour can directly click on the link to take them to the page. How is…
Adil B
  • 14,635
  • 11
  • 60
  • 78
1
vote
1 answer

Does Contour support filtering by regex?

How can I filter my data in Contour to keep only rows for which a given column matches a given pattern? For example, in SQL, one would SELECT * FROM table WHERE column ~ '^ABC[1-7]'. However using column ~ '^ABC[1-7]' in Contour expression board…
Adil B
  • 14,635
  • 11
  • 60
  • 78
1
vote
1 answer

How can I save a Contour analysis as a dataset in Foundry?

How can I save the current values of the output of a Contour path as a snapshot dataset in Foundry?
Adil B
  • 14,635
  • 11
  • 60
  • 78
0
votes
0 answers

Foundry-Contour: Finding multiple answers for multiple rows of one indicator, multiple times

I have thousands of 'tickets' which have anywhere from 1-5 scheduled meeting,on different days. I need to check every ticket, pull the final number for those meetings, and produce it for a PowerBI report. For example, Ticket 1 has 2 meetings…
Tukwut
  • 1
  • 1
0
votes
1 answer

How can I open up a copy of a Contour analysis from within Workshop?

I was wondering whether it is possible to have a button within Workshop that on click creates and opens a copy of an already existing contour analysis?
Max Magid
  • 245
  • 1
  • 8
0
votes
0 answers

PivotChart (for multi x-axis) in Contour or different way?

I do some analysis in Contour and I try to find a way to display into a bar chart, 2 x-axis dimensions as we can do with a PivotChart. For the moment I can’t find a solution for having a second dimension in the x-axis. Adding an overlay does not…
Jey
  • 1
  • 1
0
votes
1 answer

How do I identify the value of a skewed task of my Foundry job?

I've looked into my job and have identified that I do indeed have a skewed task. How do I determine what the actual value is inside this task that is causing the skew? My Python Transforms code looks like this: from transforms.api import Input,…
vanhooser
  • 1,497
  • 3
  • 19
0
votes
1 answer

How do I identify that my Foundry job's stage has skew?

I have a job running with a stage that seems to be taking a long time. I've heard that this might be due to something called 'skew'. How do I know if I'm being impacted by this? I know this is commonly associated with joins, windows, and other…
vanhooser
  • 1,497
  • 3
  • 19
0
votes
1 answer

How to parse the complete set of records for a dataset through an API call?

How can I get the full dataset records through foundry API call? I want to use the dataset in another Python application outside Foundry and using requests only first 300 rows of records are coming. The requests API end point I have is using Contour…
Asher
  • 175
  • 11
0
votes
1 answer

Embed a Contour board in an iframe in Object Explorer or Slate

In Foundry, how can I embed a Contour board in an iframe in Object Explorer or Slate?
Andrew St P
  • 524
  • 1
  • 5
  • 13
0
votes
1 answer

How to sort a table by two columns in Contour?

I have a dataset and I want to sort the data in the table view by two columns, not just one. How can I achieve this in Contour?
Andrew St P
  • 524
  • 1
  • 5
  • 13
0
votes
1 answer

How do you derive the day of week in Foundry Contour?

I want to derive a column for day of week for a time value. There are DAY_OF_MONTH and DAY_OF_YEAR functions in Contour, but not one for day of week. How can I derive the day of the week using Contour?
Adil B
  • 14,635
  • 11
  • 60
  • 78
0
votes
1 answer

Why do I sometimes get a malformed data error for some Contour boards but not others?

I have a dataset that when being used as an input to build another dataset results in a 'malformed record' error indicating that something is wrong with the raw data file (some malformed values). I would therefore expect not to be able to use that…
Wells Wulsin
  • 23
  • 5
0
votes
1 answer

How do I Join on NULL values in Contour?

I need to join two datasets in Contour on a column that contains NULLs. Contour drops NULLs when performing joins, but in this case, it's important to match the NULLs across this dataset. How can I do this?
Adil B
  • 14,635
  • 11
  • 60
  • 78
0
votes
1 answer

Exploding, un-nesting or flattening an array in Contour

I have a dataset with a column of type array, and I would like to transform the dataset by exploding the array so that each row containing N array values is transformed into N rows, each containing a single value from the array in that column. Is…
Andrew St P
  • 524
  • 1
  • 5
  • 13
1
2
3