What kind of files can I import if I am importing multiple .csv files from a folder into one input data tool? I have different kinds of files. Some of them have different numbers of rows/columns from the template file while the field names are also different from the template in some of these files.
Hi @mishail_iqbal, using the *.csv approach within the Input tool will bring-in multiple csv files as long as they have the same column names (there is no restriction to the number of rows that can be brought in). If you are looking to read multiple csv files which have different number of columns or the column names change across multiple files, you will need to create a macro to bring-in the data. The key element within the macro is to setup the following config:
Thank you so much for helping me out! Just to clarify, if I import using the wild card and don't apply the macro, then only the files where the number of rows is different will be imported, while the files with different column names and different number of columns will not be imported. Is that correct?
@mishail_iqbal if you are doing it in one Input Data tool, it is expecting the files to have the same schema which means that the column names will be the same and the data types in each column will be the same.
Hi @mishail_iqbal ,
As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.
To answer your follow up question - yes, different schemas will error when using wildcards. the field names and types need to be the exact same with wildcard. the macro will union by name (or position - depending on your setup).
Our app has a lot of dynamically generated identifiers that fill portions of our URLs. These IDs change depending on the user, the project, the company, etc. So what I'm trying to figure out is how I can make this example URL:
I'm in the process of detailing this custom attribute request for our engineering team. One thing I'm trying to better understand is how attributes like this are sent as attributes of a user.
The way our system works, 12 digit IDs are created for the URL structure. And multiple different users can view the same URL. However, these unique IDs are attributes of projects in the system, not users. And since (I believe) Intercom's notion of custom attributes are bound to users, I'm wondering how that works.
Hi Roy- I appreciate your solution. That actually is a great option for the rules logic of presenting a tour. So thank you! The outstanding issue that still persists is more specific to the "share anywhere" link. In order to post a link to a product tour, I need to be able to replace our static unique IDs with something that wildcards those pieces. Does that make sense?
Has anyone been able to get a Product Tour to launch on-demand with the users current URL? I believe this is what most of us are trying to accomplish. We don't want to start it automatically, we want to send it to a user, or have our app launch it for the user and use the current URL as the starting point.
The "Use Tour Everywhere" setting can use Custom Attributes, but my testing has been inconsistent. I am using the Javascript library to update the Unique Page ID, right before launching the tour, but it isn't working every time. Even when I send updates through the browser console. I can start a chat, and refresh the chat to see my custom data attribute update on Intercom User profile, but when I start the tour it still fails frequently.
Hi Jeff - Sure sounds like you're in the same camp with a lot of the rest of us. I still haven't managed to sort out a solution to my initial issue of the "Use tour everywhere" feature. It appears the big break down within the functionality is use of any dynamic URL component. I'm keeping my fingers crossed that this has come up enough and has made it to their product roadmap ?
My users will be only need to initiate the tour when they are on the current page with the unique ID. They would receive the Tour link via Chat or from the application when applicable. They would never receive an email that contains the Tour of a unique ID they may have been working on. What use case is applicable to you?
Intercom has suggested I use the "referral url" parameter as my "Use Tour Everywhere" url that should be the current users URL. Therefore, we take the need to track the Unique ID's out of the equation. In theory, this should work for the use case in which the user only executes the tour when they are on the page in question.
Hi Jeff- Just got a chance to watch that screen cap you did. While your use case is a little different than mine, it's good to see what you worked through for reference. Thanks for taking the time on it!
This probably has a real simple answer but it has got me stumped. How do I do wild card searches in 4.x PAN Traffic logs ? For example, I want to find all traffic from a Class C subnet 192.168.1.x. Using a * does not seem to work ( ( addr.src in 192.168.1.* ) ) and throws a syntax error.
Is there a way to perform what I would call a wild card search in the "Item" table, by the "Description" field, or I should say a partial description search. Example: if I want to find anything with "FORK" in the description field. So when running the search it I could get descriptions with Fork and spoon or Fork clamps or Silver forks etc.. everything that has fork somewhere in the description field.
You come to the table for a quick pick-up, hoping to scam and run before the marks get wise to the real game being played. The woman at the table looks nonchalant, but that doesn't fool you. She drops a card from one hand and snatches it with the other, and you almost miss it: her free hand had a card sliding out of the sleeve.
Quick breakdown of this lady with the fancy gunwork! On your second spell, Stella Lee bottles the top card of your library until your next turn ends. This is okay card draw, but ultimately only comparable to Jori En, Ruin Diver (and she's not really putting up numbers). The real juice is in the tap ability: copy an instant or sorcery, but only if you've cast three or more spells.
She's got card flow and a splashy effect, provided you jump through the hoop. It's important to note that she only asks for spells to be cast, not specifically instants and sorceries (though she can only copy those). Also, she specifies "each turn." These both help with deckbuilding constraints, as we'll talk about shortly.
Our commander in question wants two things: cast three spells in a turn and cast, preferably, a big instant or sorcery (look, copying an Opt is value, but you're not exactly winning the game off the back of it). This merits a mix of low mana value and high mana value.
One mana cantrips are perfect. You know 'em, you love 'em - Brainstorm and Serum Visions are especially beloved for setting up the top card afterwards for the bottling effect. See the Truth might be "too cute" in more optimized builds, but I'm game! It'll play really great if you lean into the possible "cast from exile" subtheme by including more impulse draw effects. I didn't, but I could see a strong argument for it.
Cheap disruption is always welcome, but my particular suite is going to minimize counterspells; I think there's an instant-heavier build that goes more in on those. We want to be able to easily chain spells on our turn, so cards like Reality Shift and Lightning Bolt help boost the storm count while acting as emergency switches when needed.
Here are the three kinds of friends Stella Lee likes to keep around. You have your Goblin Electromancers, who reduce the costs of our instants and sorceries. You have your Young Pyromancers, who build us a little board of tokens with all the spells slung about. Then there's the Archmage Emeritus types, who generate non-board value thanks to those spells.
This is a major diverging point. I've had Spellslinger decks in the past which focused more on Young Pyromancer styles of using spells to crank out a lot of tokens, so I pulled back on that here, using only four in total. I imagine Stella Lee to be more focused on generating one or two major turns with a copied big spell, so the token plan is out for me; the amount we have is mostly to ensure we generate a few extra chump blockers while working towards that turn.
Notably, there just aren't a lot below four mana, but I included what I reasonably could. The four-mana ones can be clunky, but they do allow for additional upsides beyond just the single pip reduction. Seeing as Stella Lee really wants to ensure a big turn, this feels like the right call for the first draft. Maybe I'll end up cutting some of these... or maybe I'll reach out and snag that Curious Homunculus to throw in also. Not sure yet!
Money's tight in this desert, but mana flows surprisingly well; even in Izzet, as it turns out. We don't have consistent ways to find lands, but the cantrip-based card flow should keep us from missing land drops.
Most of our mana acceleration is going to come from mana rocks, like the usual suspects: Sol Ring, Izzet Signet, Talisman of Creativity, and Arcane Signet. Most decks want rocks that provide colored mana, enter untapped, and are low mana value; that's nothing new, but those features are especially important here. If we draw a mana rock in the late game, it can still be used to count to three, but we need to maximize its usefulness there. Thought Vessel and Mind Stone are still worth trying for this reason, even if they're awkward with how many one-mana spells we have.
A major source of mana throughout the game will be the previously discussed cost-reducing permanents, but those are slow sources of value. If we want to really strike out and get our big turns in, sometimes we need a huge, temporary burst. That's where mana rituals come in! Seething Song, Jeska's Will, and a few others join the deck to up the count and occasionally help cast Comet Storm for 53.
b37509886e